home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgLangD.iso / Borland Visual dBASE Professiona v7.0 / DATA1.CAB / Sample_dBASE / Mugs / Customer.sql < prev    next >
Text File  |  1997-11-20  |  313b  |  5 lines
  1. --Database:MUGS
  2. SELECT Customer."First Name", Customer.STREET2, Customer.STREET1, Customer.CITY, Customer."State ID", Customer.POSTAL, Country.Country, Customer."Last Name", Customer.Phone
  3. FROM "customer.dbf" Customer
  4.    INNER JOIN "country.dbf" Country
  5.    ON  (Customer."Country ID" = Country."Country ID")